IF exists(SELECT * FROM dbo.sysobjects WHERE name='WEB_fcCode' AND xtype='P') 
BEGIN
	DROP PROCEDURE WEB_fcCode
END
GO

create  procedure WEB_fcCode
(@naamcode char(4))
as
select codeLeraar from kopiesLeraars
where naamcode=@naamcode